CONNECT BY
Short Description
CONNECT BY describes how LEVELs are created within hierarchical queries
Detailed Description
CONNECT BY describes how LEVELs are created within hierarchical queries. A hierarchical query needs a definition of how child and parent records are related.
The syntax is:
{CONNECT BY [NOCYCLE ] condition [START WITH condition ]
|START WITH conditionCONNECT BY [NOCYCLE ] condition
}
Additional Links
- Tim Hall’s Oracle Base viedo clip - Hierarchical Queries in Oracle
- Oracle SQL Ref - Hierarchical Queries
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.